M S OFFICE

 

ms word

 

1.       AN INTRODUCTION TO WORD

          The Word workspace, Starting and quitting Word, Creating and Manipulating Various documents, Editing of proofing files, Merging documents and macros

2.       HOW TO USE MOUSE AND MENU

          Working with dialog box

 

3.       PRIMARY COMMANDS IN FILE MENU

          The Open Commands, The File name commands, The New commands, The Save , Save As, and Save all  commands, The Close command, The Page setup, The Print commands, The Exit commands

 

4.       EDIT MENU COMMANDS

          The Cut, Copy, and Paste commands, The Undo and Repeat commands, Find and Replace commands.        

 

5.       FORMAT COMMANDS

          Font commands, Paragraph commands, Bullets and Numbering, Background, Style, Tab, Columns, Drop Cap

 

6.       OTHER MENU

          The view menu, The Insert menu, the tool menu, the table menu, The Window menu

 

spread sheet preparation using ms excel

 

1.       BUILDING A SIMPLE WORKSHEET

          Entering Text, Entering Values, Entering Dates and Times, Moving Around, Selecting Ranges, Using Menu, Using Tool Bar, Using Shortcut Menus, Changing entries, Copying entries, Moving Entries, Inserting and Deleting cells

 

2.       FORMATTING BASICS

          Changing Character Style, Changing Alignment, Changing Column Width, Changing Row Height, Sheet Rename, Conditional Formatting, Auto Formatting

 

3.       WORKING WITH MULTIPLE WORKSHEET

          Copying entries between work books, Moving sheets between work books, Deleting sheets,   Quitting Excel

 

4.       OPENING EXISTING WORKBOOKS

          Simple calculations, Doing Arithmetic, Totaling column of values, Naming cells and Ranges

 

5.       FORMATTING TEXT

          Displaying dollars and cents, Formatting decimal places, Formatting dates, Copying style and formats

 

6.       FORMULAS THAT MAKE DECISIONS

          Using the IF function, using the nested IF function, copying formulas             

 

7         Checking Spelling, Printing Worksheets, Preview Worksheets, Goal seek, Scenarios, Macro, Protection

8.       Sorting data, Keeping Leading in View, Finding records, Adding and deleting Records, Filtering Records

 

9.       Plotting charts, Sizing and moving charts, Updating charts, Changing the chart type, Using chart auto format

         

10.     Creating Macros, Recording Macros, Running Macros

 

database concepts using ms access

 

 

1.          Introduction to Database

             Database System Concepts, DBMS and RDBMS

 

2.          Planning and Designing a Database

 

3.          Creating a Database

             Sorting Data in Tables, Fields, Records, Two ways to Create a Database, Creating a Database with Database Wizard

 

4.          Building and Modifying Tables

             Create Tables by using the Table Wizard, Create Tables from Scratch, Field Names

             Data Types and Filed Properties, Modify Tables Using Design View, Entering Data in a Data sheet, Editing Data in a Datasheet, Changing the Width of Columns and Height of Rows, Changing the Order of Columns, Setting of Primary Key

 

5.          Defining Relationship

             Establish Relationship, Enforce Referential Integrity

 

6.          Querying a Database

             Constructing a Query, Creating the Query, Choose the Tables to Query, Field to Query, Entering the Query criteria, Saving the Results of a Query

 

7.          Different kinds of Queries

             Cross Tab, Update, Delete, Append, Make Table

 

8.          Building and Modifying Forms

      For Entering and Viewing Data, Creating a Form (Design View of Form Wizard), Use the Control Toolbox to Add Controls, Modify Format Properties (Font Style, Size, Color, Caption, etc.) of Controls, Use of Form Sections (Header, Footers and Detail), Use of Calculated Control on a Form

slide presentation using ms power point

 

1.       POWER POINT

          Main Features of Power Point

 

2.       Making the Presentation

          Creating Template with the Auto Content Wizard. Creating a Presentation with a Template.  Creating a presentation from Scratch

 

3        Different Views

          Normal Slide, Outline, Slide Sorter, Slide Show, Notes, Slide Master

 

4        Animation, Art and Sound

          Controlling Transitions between slides.  Animating Different Parts of a slide.  Inserting a Motion Clip.  Including Sounds in slides.

 

5.       Including Graphs, Charts, Tables and Columns

          Organisation Chart Slide, Creating a table Slide.  Creating two column Slide, Module  1: Showing  A Presentation, Rehearsing/ Timing a Presentation, Designating some slides as “Hidden”, Viewing Slides Anywhere in a Slide Show.

 

6.       Techniques for Making a Show Livelier

 

7.       Office Connections

          Presenting with the help of other Office Programs Importing the text from a Word Document.

 

8.       Printing a Presentation